<?php
$page = 'admin';
include_once 'header.php';
?>
<p>
Admin home
</p>

<ul style="text-transform: capitalize">
        <li><a href="courses.php"> Add/View Courses</a></li>
       <li> Available courses</li>
       <ul>
            <?php
            $query = "SELECT * FROM courses order by course asc";
            $result = mysql_query($query) or die("Error executing '$query':" . mysql_error());
            while ($row = mysql_fetch_assoc($result)) {
                extract($row);
                echo "<li>$course</li><br/>";
            }
            ?>
       </ul>
        </ul>
   

    <?php include_once 'footer.php'; ?> 